SELECT
<${r"#"}assign prefixName = ' '>
<#list entityMapper.fieldMapperMap?values as fieldMapper>
    <${r"#"}if
            (select_${fieldMapper.code}??)>
    ${r"$"}{prefixName} T.${fieldMapper.columnName} AS "${fieldMapper.code}"
        <${r"#"}assign prefixName = ','>
    </${r"#"}if>
</#list>
    <${r"#"}if prefixName==
    ' '>
<#assign prefixName = ' '>
<#list entityMapper.fieldMapperMap?values as fieldMapper>
${prefixName} T.${fieldMapper.columnName} AS "${fieldMapper.code}"
    <#assign prefixName = ','>
</#list>
    </${r"#"}if>
    FROM ${entityMapper.tableName} T
    <${r"#"}include
    "whereByCode.ftl">
    <${r"#"}assign prefixName = 'ORDER BY'>
    <#list entityMapper.fieldMapperMap?values as fieldMapper>
        <${r"#"}if
                (order_by_${fieldMapper.code}??)>
        ${r"$"}{prefixName} T.${fieldMapper.columnName} ${r"$"}{order_by_${fieldMapper.code}_value!}
            <${r"#"}assign prefixName = ','>
        </${r"#"}if>
    </#list>
